using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Data;
namespace Test.Support {
	class LocAdj {
		static void MainX() {
			Console.WriteLine(DateTime.Now.DayOfYear );
			List<string> lst=new List<string>();
			lst.Add("pon-wpsq03-db,ntn2");
			lst.Add("pon-wpsq03-db,overseas3");
			lst.Add("pon-wpsq12-db,DearnePallet");
			lst.Add("pon-wpsq21-db02\\in02,elmsall");
			lst.Add("pon-wpsq21-db06\\in06,doncaster");
			lst.Add("pon-wpsq21-db07\\in07,DearnePallet");
			lst.Add("pon-wpsq21-db08\\in08,stadium2");
			lst.Add("pon-wpsq21-db08\\in08,stadiumWay");
			lst.Add("pon-wpsq21-db10\\in10,graphics");
			lst.Add("pon-wpsq21-db10\\in10,heywood");
			lst.Add("pon-wpsq21-db10\\in10,worksop");
			foreach(string str in lst)
			{
				string[] ar=str.Split(',');
				DAL dal=new DAL(ar[0],ar[1]);
				DataTable tab1=dal.Query("select * from up_locadj(nolock)");
				Console.WriteLine(tab1.Rows.Count);
			}
		}
	}
}
